Dataset info
| Number of variables | 54 |
|---|---|
| Number of observations | 7043 |
| Missing cells | 10348 (2.7%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 8.7 MiB |
| Average record size in memory | 1.3 KiB |
Variables types
| BOOL | 20 |
|---|---|
| NUM | 20 |
| CAT | 14 |
Reproduction info
| Date of analysis | 2020-05-07 21:42:41.328454 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
Avg_Monthly_GB_Download has 1526 (21.7%) zeros | Zeros |
Avg_Monthly_Long_Distance_Charges has 682 (9.7%) zeros | Zeros |
Churn_Category has 5174 (73.5%) missing values | Missing |
Churn_Reason has 5174 (73.5%) missing values | Missing |
City has a high cardinality: 1106 distinct values | Warning |
Count has constant value "1" | Rejected |
Country has constant value "United States" | Rejected |
Customer_ID has a high cardinality: 7043 distinct values | Warning |
Lat_Long has a high cardinality: 1679 distinct values | Warning |
Number_of_Dependents has 5416 (76.9%) zeros | Zeros |
Number_of_Referrals has 3821 (54.3%) zeros | Zeros |
Quarter has constant value "Q3" | Rejected |
State has constant value "California" | Rejected |
Total_Extra_Data_Charges has 6315 (89.7%) zeros | Zeros |
Total_Long_Distance_Charges has 682 (9.7%) zeros | Zeros |
Total_Refunds has 6518 (92.5%) zeros | Zeros |
Latitude is highly correlated with ID | High Correlation |
ID is highly correlated with Latitude and 1 other fields | High Correlation |
Total_Revenue is highly correlated with Total_Charges | High Correlation |
Total_Charges is highly correlated with Total_Revenue | High Correlation |
Zip_Code is highly correlated with ID | High Correlation |
Quarter is highly correlated with Country and 1 other fields | High Correlation |
Country is highly correlated with Quarter and 1 other fields | High Correlation |
State is highly correlated with Country and 1 other fields | High Correlation |
Age
Real number (ℝ≥0)
| Distinct count | 62 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.50972597 |
|---|---|
| Minimum | 19 |
| Maximum | 80 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 110.0 KiB |
Quantile statistics
| Minimum | 19 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 32 |
| median | 46 |
| Q3 | 60 |
| 95-th percentile | 75 |
| Maximum | 80 |
| Range | 61 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 16.75035166 |
|---|---|
| Coefficient of variation (CV) | 0.3601472876 |
| Kurtosis | -1.00284948 |
| Mean | 46.50972597 |
| Median Absolute Deviation (MAD) | 14.23865567 |
| Skewness | 0.1621864487 |
| Sum | 327568 |
| Variance | 280.5742806 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[19. 19.5 64.5 79.5 80. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 42 | 156 | 2.2% | |
| 47 | 153 | 2.2% | |
| 40 | 150 | 2.1% | |
| 44 | 148 | 2.1% | |
| 23 | 146 | 2.1% | |
| 56 | 144 | 2.0% | |
| 62 | 143 | 2.0% | |
| 35 | 142 | 2.0% | |
| 21 | 140 | 2.0% | |
| 33 | 139 | 2.0% | |
| Other values (52) | 5582 | 79.3% |
| Value | Count | Frequency (%) | |
| 19 | 127 | 1.8% | |
| 20 | 127 | 1.8% | |
| 21 | 140 | 2.0% | |
| 22 | 130 | 1.8% | |
| 23 | 146 | 2.1% |
| Value | Count | Frequency (%) | |
| 80 | 66 | 0.9% | |
| 79 | 76 | 1.1% | |
| 78 | 63 | 0.9% | |
| 77 | 72 | 1.0% | |
| 76 | 69 | 1.0% |
| Distinct count | 50 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.51540537 |
|---|---|
| Minimum | 0 |
| Maximum | 85 |
| Zeros | 1526 |
| Zeros (%) | 21.7% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 17 |
| Q3 | 27 |
| 95-th percentile | 69 |
| Maximum | 85 |
| Range | 85 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 20.41894039 |
|---|---|
| Coefficient of variation (CV) | 0.995297925 |
| Kurtosis | 0.8815023103 |
| Mean | 20.51540537 |
| Median Absolute Deviation (MAD) | 15.49305313 |
| Skewness | 1.216583903 |
| Sum | 144490 |
| Variance | 416.9331267 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 1. 2.5 10.5 18.5 ... 64. 72. 74. 83.5 85. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 1526 | 21.7% | |
| 19 | 220 | 3.1% | |
| 27 | 199 | 2.8% | |
| 30 | 193 | 2.7% | |
| 59 | 192 | 2.7% | |
| 26 | 191 | 2.7% | |
| 23 | 179 | 2.5% | |
| 22 | 172 | 2.4% | |
| 21 | 171 | 2.4% | |
| 13 | 164 | 2.3% | |
| Other values (40) | 3836 | 54.5% |
| Value | Count | Frequency (%) | |
| 0 | 1526 | 21.7% | |
| 2 | 116 | 1.6% | |
| 3 | 130 | 1.8% | |
| 4 | 129 | 1.8% | |
| 5 | 114 | 1.6% |
| Value | Count | Frequency (%) | |
| 85 | 48 | 0.7% | |
| 82 | 43 | 0.6% | |
| 76 | 58 | 0.8% | |
| 75 | 15 | 0.2% | |
| 73 | 81 | 1.2% |
| Distinct count | 3584 |
|---|---|
| Unique (%) | 50.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.95895357 |
|---|---|
| Minimum | 0 |
| Maximum | 49.99 |
| Zeros | 682 |
| Zeros (%) | 9.7% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.21 |
| median | 22.89 |
| Q3 | 36.395 |
| 95-th percentile | 47.34 |
| Maximum | 49.99 |
| Range | 49.99 |
| Interquartile range (IQR) | 27.185 |
Descriptive statistics
| Standard deviation | 15.44811335 |
|---|---|
| Coefficient of variation (CV) | 0.6728579026 |
| Kurtosis | -1.25465441 |
| Mean | 22.95895357 |
| Median Absolute Deviation (MAD) | 13.47216416 |
| Skewness | 0.04917589934 |
| Sum | 161699.91 |
| Variance | 238.6442059 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.505 1.015 49.99 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 682 | 9.7% | |
| 18.26 | 7 | 0.1% | |
| 34.49 | 6 | 0.1% | |
| 30.07 | 6 | 0.1% | |
| 18.42 | 6 | 0.1% | |
| 10.11 | 6 | 0.1% | |
| 22.83 | 6 | 0.1% | |
| 42.55 | 6 | 0.1% | |
| 45.92 | 6 | 0.1% | |
| 22.56 | 6 | 0.1% | |
| Other values (3574) | 6306 | 89.5% |
| Value | Count | Frequency (%) | |
| 0 | 682 | 9.7% | |
| 1.01 | 1 | < 0.1% | |
| 1.02 | 3 | < 0.1% | |
| 1.03 | 1 | < 0.1% | |
| 1.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 49.99 | 1 | < 0.1% | |
| 49.98 | 3 | < 0.1% | |
| 49.96 | 2 | < 0.1% | |
| 49.95 | 2 | < 0.1% | |
| 49.94 | 1 | < 0.1% |
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 338.5 KiB |
| Competitor | |
|---|---|
| Attitude | |
| Dissatisfaction | |
| Price | |
| Other |
| Value | Count | Frequency (%) | |
| Competitor | 841 | 11.9% | |
| Attitude | 314 | 4.5% | |
| Dissatisfaction | 303 | 4.3% | |
| Price | 211 | 3.0% | |
| Other | 200 | 2.8% | |
| (Missing) | 5174 | 73.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 15 |
|---|---|
| Mean length | 4.691750674 |
| Min length | 3 |
Churn_Label
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 5174 | 73.5% | |
| Yes | 1869 | 26.5% |
| Distinct count | 21 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 5174 |
| Missing (%) | 73.5% |
| Memory size | 338.5 KiB |
| Competitor had better devices | |
|---|---|
| Competitor made better offer | |
| Attitude of support person | |
| Don't know | 130 |
| Competitor offered more data | 117 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| Competitor had better devices | 313 | 4.4% | |
| Competitor made better offer | 311 | 4.4% | |
| Attitude of support person | 220 | 3.1% | |
| Don't know | 130 | 1.8% | |
| Competitor offered more data | 117 | 1.7% | |
| Competitor offered higher download speeds | 100 | 1.4% | |
| Attitude of service provider | 94 | 1.3% | |
| Price too high | 78 | 1.1% | |
| Product dissatisfaction | 77 | 1.1% | |
| Network reliability | 72 | 1.0% | |
| Other values (10) | 357 | 5.1% | |
| (Missing) | 5174 | 73.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 41 |
|---|---|
| Mean length | 8.906289933 |
| Min length | 3 |
Churn_Score
Real number (ℝ≥0)
| Distinct count | 81 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.50504047 |
|---|---|
| Minimum | 5 |
| Maximum | 96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 40 |
| median | 61 |
| Q3 | 75.5 |
| 95-th percentile | 91 |
| Maximum | 96 |
| Range | 91 |
| Interquartile range (IQR) | 35.5 |
Descriptive statistics
| Standard deviation | 21.17003078 |
|---|---|
| Coefficient of variation (CV) | 0.3618496904 |
| Kurtosis | -1.085289995 |
| Mean | 58.50504047 |
| Median Absolute Deviation (MAD) | 18.25163382 |
| Skewness | -0.1568522156 |
| Sum | 412051 |
| Variance | 448.1702032 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 5. 14.5 20.5 64.5 80.5 89.5 90.5 91.5 95.5 96. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 91 | 202 | 2.9% | |
| 80 | 150 | 2.1% | |
| 71 | 148 | 2.1% | |
| 77 | 145 | 2.1% | |
| 67 | 142 | 2.0% | |
| 76 | 140 | 2.0% | |
| 68 | 140 | 2.0% | |
| 90 | 139 | 2.0% | |
| 70 | 138 | 2.0% | |
| 69 | 138 | 2.0% | |
| Other values (71) | 5561 | 79.0% |
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 9 | 3 | < 0.1% | |
| 20 | 83 | 1.2% |
| Value | Count | Frequency (%) | |
| 96 | 49 | 0.7% | |
| 95 | 46 | 0.7% | |
| 94 | 46 | 0.7% | |
| 93 | 50 | 0.7% | |
| 92 | 51 | 0.7% |
Churn_Value
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 5174 | 73.5% | |
| 1 | 1869 | 26.5% |
| Distinct count | 1106 |
|---|---|
| Unique (%) | 15.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Los Angeles | 293 |
|---|---|
| San Diego | 285 |
| San Jose | 112 |
| Sacramento | 108 |
| San Francisco | 104 |
| Other values (1101) |
| Value | Count | Frequency (%) | |
| Los Angeles | 293 | 4.2% | |
| San Diego | 285 | 4.0% | |
| San Jose | 112 | 1.6% | |
| Sacramento | 108 | 1.5% | |
| San Francisco | 104 | 1.5% | |
| Fresno | 61 | 0.9% | |
| Long Beach | 60 | 0.9% | |
| Oakland | 52 | 0.7% | |
| Escondido | 51 | 0.7% | |
| Stockton | 44 | 0.6% | |
| Other values (1096) | 5873 | 83.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 22 |
|---|---|
| Mean length | 9.203464433 |
| Min length | 3 |
CLTV
Real number (ℝ≥0)
| Distinct count | 3438 |
|---|---|
| Unique (%) | 48.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4400.295755 |
|---|---|
| Minimum | 2003 |
| Maximum | 6500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 2003 |
|---|---|
| 5-th percentile | 2296 |
| Q1 | 3469 |
| median | 4527 |
| Q3 | 5380.5 |
| 95-th percentile | 6087 |
| Maximum | 6500 |
| Range | 4497 |
| Interquartile range (IQR) | 1911.5 |
Descriptive statistics
| Standard deviation | 1183.057152 |
|---|---|
| Coefficient of variation (CV) | 0.2688585536 |
| Kurtosis | -0.934032483 |
| Mean | 4400.295755 |
| Median Absolute Deviation (MAD) | 994.7244369 |
| Skewness | -0.3116021004 |
| Sum | 30991283 |
| Variance | 1399624.225 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[2003. 3999.5 5996.5 6500. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 5546 | 8 | 0.1% | |
| 4741 | 7 | 0.1% | |
| 5137 | 7 | 0.1% | |
| 2269 | 7 | 0.1% | |
| 4115 | 7 | 0.1% | |
| 4745 | 7 | 0.1% | |
| 5461 | 7 | 0.1% | |
| 4369 | 7 | 0.1% | |
| 5092 | 7 | 0.1% | |
| 5527 | 7 | 0.1% | |
| Other values (3428) | 6972 | 99.0% |
| Value | Count | Frequency (%) | |
| 2003 | 3 | < 0.1% | |
| 2004 | 3 | < 0.1% | |
| 2006 | 1 | < 0.1% | |
| 2007 | 4 | 0.1% | |
| 2008 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6500 | 1 | < 0.1% | |
| 6499 | 2 | < 0.1% | |
| 6495 | 1 | < 0.1% | |
| 6494 | 2 | < 0.1% | |
| 6492 | 3 | < 0.1% |
Contract
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Month-to-Month | |
|---|---|
| Two Year | |
| One Year |
| Value | Count | Frequency (%) | |
| Month-to-Month | 3610 | 51.3% | |
| Two Year | 1883 | 26.7% | |
| One Year | 1550 | 22.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 11.07539401 |
| Min length | 8 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.0 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 7043 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| United States |
|---|
| Value | Count | Frequency (%) | |
| United States | 7043 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 13 |
|---|---|
| Mean length | 13 |
| Min length | 13 |
| Distinct count | 7043 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| 9518-XXBXE | 1 |
|---|---|
| 5075-JSDKI | 1 |
| 6680-NENYN | 1 |
| 6496-JDSSB | 1 |
| 2465-BLLEU | 1 |
| Other values (7038) |
| Value | Count | Frequency (%) | |
| 9518-XXBXE | 1 | < 0.1% | |
| 5075-JSDKI | 1 | < 0.1% | |
| 6680-NENYN | 1 | < 0.1% | |
| 6496-JDSSB | 1 | < 0.1% | |
| 2465-BLLEU | 1 | < 0.1% | |
| 9964-WBQDJ | 1 | < 0.1% | |
| 9972-EWRJS | 1 | < 0.1% | |
| 7672-VFMXZ | 1 | < 0.1% | |
| 2369-FEVNO | 1 | < 0.1% | |
| 6685-XSHHU | 1 | < 0.1% | |
| Other values (7033) | 7033 | 99.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
Customer_Status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Stayed | |
|---|---|
| Churned | |
| Joined | 454 |
| Value | Count | Frequency (%) | |
| Stayed | 4720 | 67.0% | |
| Churned | 1869 | 26.5% | |
| Joined | 454 | 6.4% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 7 |
|---|---|
| Mean length | 6.265369871 |
| Min length | 6 |
Dependents
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 5416 | 76.9% | |
| Yes | 1627 | 23.1% |
Device_Protection_Plan
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4621 | 65.6% | |
| Yes | 2422 | 34.4% |
Gender
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Male | |
|---|---|
| Female |
| Value | Count | Frequency (%) | |
| Male | 3555 | 50.5% | |
| Female | 3488 | 49.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 6 |
|---|---|
| Mean length | 4.990487008 |
| Min length | 4 |
| Distinct count | 1626 |
|---|---|
| Unique (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 784.8006531 |
|---|---|
| Minimum | 1 |
| Maximum | 1670 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 73.1 |
| Q1 | 353 |
| median | 759 |
| Q3 | 1208 |
| 95-th percentile | 1574.9 |
| Maximum | 1670 |
| Range | 1669 |
| Interquartile range (IQR) | 855 |
Descriptive statistics
| Standard deviation | 489.0440495 |
|---|---|
| Coefficient of variation (CV) | 0.6231442948 |
| Kurtosis | -1.24297351 |
| Mean | 784.8006531 |
| Median Absolute Deviation (MAD) | 427.8197241 |
| Skewness | 0.1384875794 |
| Sum | 5527351 |
| Variance | 239164.0824 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.000e+00 3.265e+02 3.285e+02 3.605e+02 3.615e+02 ... 3.785e+02 3.805e+02 5.315e+02 5.325e+02 1.670e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 328 | 43 | 0.6% | |
| 327 | 38 | 0.5% | |
| 373 | 36 | 0.5% | |
| 368 | 34 | 0.5% | |
| 376 | 32 | 0.5% | |
| 532 | 30 | 0.4% | |
| 361 | 27 | 0.4% | |
| 380 | 22 | 0.3% | |
| 372 | 20 | 0.3% | |
| 379 | 16 | 0.2% | |
| Other values (1616) | 6745 | 95.8% |
| Value | Count | Frequency (%) | |
| 1 | 4 | 0.1% | |
| 2 | 4 | 0.1% | |
| 3 | 5 | 0.1% | |
| 4 | 5 | 0.1% | |
| 5 | 4 | 0.1% |
| Value | Count | Frequency (%) | |
| 1670 | 2 | < 0.1% | |
| 1669 | 4 | 0.1% | |
| 1668 | 4 | 0.1% | |
| 1667 | 3 | < 0.1% | |
| 1666 | 4 | 0.1% |
Internet_Service
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Yes | |
|---|---|
| No |
| Value | Count | Frequency (%) | |
| Yes | 5517 | 78.3% | |
| No | 1526 | 21.7% |
Internet_Type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Fiber Optic | |
|---|---|
| DSL | |
| None | |
| Cable |
| Value | Count | Frequency (%) | |
| Fiber Optic | 3035 | 43.1% | |
| DSL | 1652 | 23.5% | |
| None | 1526 | 21.7% | |
| Cable | 830 | 11.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 11 |
|---|---|
| Mean length | 6.899758626 |
| Min length | 3 |
| Distinct count | 1679 |
|---|---|
| Unique (%) | 23.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| 33.362575, -117.299644 | 43 |
|---|---|
| 33.141265, -116.967221 | 38 |
| 32.825086, -117.199424 | 34 |
| 32.886925, -117.152162 | 32 |
| 33.507255, -117.029473 | 30 |
| Other values (1674) |
| Value | Count | Frequency (%) | |
| 33.362575, -117.299644 | 43 | 0.6% | |
| 33.141265, -116.967221 | 38 | 0.5% | |
| 32.825086, -117.199424 | 34 | 0.5% | |
| 32.886925, -117.152162 | 32 | 0.5% | |
| 33.507255, -117.029473 | 30 | 0.4% | |
| 32.957195, -117.202542 | 22 | 0.3% | |
| 32.898613, -117.202937 | 20 | 0.3% | |
| 32.961064, -117.134917 | 16 | 0.2% | |
| 34.102119, -117.815532 | 8 | 0.1% | |
| 33.840524, -118.148403 | 7 | 0.1% | |
| Other values (1669) | 6793 | 96.5% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 22 |
|---|---|
| Mean length | 21.78418288 |
| Min length | 18 |
| Distinct count | 1626 |
|---|---|
| Unique (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.19745482 |
|---|---|
| Minimum | 32.555828 |
| Maximum | 41.962127 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 32.555828 |
|---|---|
| 5-th percentile | 32.886925 |
| Q1 | 33.990646 |
| median | 36.205465 |
| Q3 | 38.161321 |
| 95-th percentile | 40.4974252 |
| Maximum | 41.962127 |
| Range | 9.406299 |
| Interquartile range (IQR) | 4.170675 |
Descriptive statistics
| Standard deviation | 2.468928682 |
|---|---|
| Coefficient of variation (CV) | 0.06820724534 |
| Kurtosis | -1.160506077 |
| Mean | 36.19745482 |
| Median Absolute Deviation (MAD) | 2.233057555 |
| Skewness | 0.3148042686 |
| Sum | 254938.6743 |
| Variance | 6.095608835 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[32.555828 32.671095 32.7416755 32.7418555 32.7865005 ... 38.731413 38.736237 39.301805 40.9570115 41.962127 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 33.362575 | 43 | 0.6% | |
| 33.141265 | 38 | 0.5% | |
| 32.85723 | 36 | 0.5% | |
| 32.825086 | 34 | 0.5% | |
| 32.886925 | 32 | 0.5% | |
| 33.507255 | 30 | 0.4% | |
| 32.787836 | 27 | 0.4% | |
| 32.957195 | 22 | 0.3% | |
| 32.898613 | 20 | 0.3% | |
| 32.961064 | 16 | 0.2% | |
| Other values (1616) | 6745 | 95.8% |
| Value | Count | Frequency (%) | |
| 32.555828 | 5 | 0.1% | |
| 32.578103 | 4 | 0.1% | |
| 32.579134 | 4 | 0.1% | |
| 32.587557 | 5 | 0.1% | |
| 32.605012 | 4 | 0.1% |
| Value | Count | Frequency (%) | |
| 41.962127 | 4 | 0.1% | |
| 41.950683 | 4 | 0.1% | |
| 41.949216 | 4 | 0.1% | |
| 41.932207 | 3 | < 0.1% | |
| 41.924174 | 3 | < 0.1% |
Longitude
Real number (ℝ)
| Distinct count | 1625 |
|---|---|
| Unique (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -119.7566837 |
|---|---|
| Minimum | -124.301372 |
| Maximum | -114.192901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | -124.301372 |
|---|---|
| 5-th percentile | -122.9755 |
| Q1 | -121.78809 |
| median | -119.595293 |
| Q3 | -117.969795 |
| 95-th percentile | -116.873258 |
| Maximum | -114.192901 |
| Range | 10.108471 |
| Interquartile range (IQR) | 3.818295 |
Descriptive statistics
| Standard deviation | 2.154425092 |
|---|---|
| Coefficient of variation (CV) | -0.01799001965 |
| Kurtosis | -1.191290554 |
| Mean | -119.7566837 |
| Median Absolute Deviation (MAD) | 1.932931396 |
| Skewness | -0.09193163502 |
| Sum | -843446.3231 |
| Variance | 4.641547478 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-124.301372 -123.8626625 -123.3672595 -123.07077 -122.5967105 ... -116.5935305 -116.092795 -115.676134 -115.464355 -114.192901 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -117.299644 | 43 | 0.6% | |
| -116.967221 | 38 | 0.5% | |
| -117.209774 | 36 | 0.5% | |
| -117.199424 | 34 | 0.5% | |
| -117.152162 | 32 | 0.5% | |
| -117.029473 | 30 | 0.4% | |
| -117.232376 | 27 | 0.4% | |
| -117.202542 | 22 | 0.3% | |
| -117.202937 | 20 | 0.3% | |
| -117.134917 | 16 | 0.2% | |
| Other values (1615) | 6745 | 95.8% |
| Value | Count | Frequency (%) | |
| -124.301372 | 4 | 0.1% | |
| -124.240051 | 4 | 0.1% | |
| -124.217378 | 4 | 0.1% | |
| -124.210902 | 4 | 0.1% | |
| -124.189977 | 4 | 0.1% |
| Value | Count | Frequency (%) | |
| -114.192901 | 4 | 0.1% | |
| -114.36514 | 5 | 0.1% | |
| -114.702256 | 4 | 0.1% | |
| -114.71612 | 4 | 0.1% | |
| -114.758334 | 5 | 0.1% |
Married
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 3641 | 51.7% | |
| Yes | 3402 | 48.3% |
Monthly_Charge
Real number (ℝ≥0)
| Distinct count | 1585 |
|---|---|
| Unique (%) | 22.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.76169246 |
|---|---|
| Minimum | 18.25 |
| Maximum | 118.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 18.25 |
|---|---|
| 5-th percentile | 19.65 |
| Q1 | 35.5 |
| median | 70.35 |
| Q3 | 89.85 |
| 95-th percentile | 107.4 |
| Maximum | 118.75 |
| Range | 100.5 |
| Interquartile range (IQR) | 54.35 |
Descriptive statistics
| Standard deviation | 30.0900471 |
|---|---|
| Coefficient of variation (CV) | 0.4646272504 |
| Kurtosis | -1.257259695 |
| Mean | 64.76169246 |
| Median Absolute Deviation (MAD) | 26.22210151 |
| Skewness | -0.2205244339 |
| Sum | 456116.6 |
| Variance | 905.4109343 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 18.25 18.775 19.175 19.525 20.275 ... 103.625 106.175 111.325 116.675 118.75 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 20.05 | 61 | 0.9% | |
| 19.85 | 45 | 0.6% | |
| 19.9 | 44 | 0.6% | |
| 19.95 | 44 | 0.6% | |
| 19.65 | 43 | 0.6% | |
| 20 | 43 | 0.6% | |
| 19.7 | 43 | 0.6% | |
| 20.15 | 40 | 0.6% | |
| 19.55 | 40 | 0.6% | |
| 20.25 | 39 | 0.6% | |
| Other values (1575) | 6601 | 93.7% |
| Value | Count | Frequency (%) | |
| 18.25 | 1 | < 0.1% | |
| 18.4 | 1 | < 0.1% | |
| 18.55 | 1 | < 0.1% | |
| 18.7 | 2 | < 0.1% | |
| 18.75 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 118.75 | 1 | < 0.1% | |
| 118.65 | 1 | < 0.1% | |
| 118.6 | 2 | < 0.1% | |
| 118.35 | 1 | < 0.1% | |
| 118.2 | 1 | < 0.1% |
Multiple_Lines
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4072 | 57.8% | |
| Yes | 2971 | 42.2% |
| Distinct count | 10 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4686923186 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros | 5416 |
| Zeros (%) | 76.9% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9628019509 |
|---|---|
| Coefficient of variation (CV) | 2.054230276 |
| Kurtosis | 4.446357934 |
| Mean | 0.4686923186 |
| Median Absolute Deviation (MAD) | 0.7208398687 |
| Skewness | 2.109931981 |
| Sum | 3301 |
| Variance | 0.9269875967 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 3.5 5.5 9. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 5416 | 76.9% | |
| 1 | 553 | 7.9% | |
| 2 | 531 | 7.5% | |
| 3 | 517 | 7.3% | |
| 5 | 10 | 0.1% | |
| 4 | 9 | 0.1% | |
| 6 | 3 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 5416 | 76.9% | |
| 1 | 553 | 7.9% | |
| 2 | 531 | 7.5% | |
| 3 | 517 | 7.3% | |
| 4 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 9 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 3 | < 0.1% | |
| 5 | 10 | 0.1% |
| Distinct count | 12 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.951867102 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros | 3821 |
| Zeros (%) | 54.3% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 9 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.0011993 |
|---|---|
| Coefficient of variation (CV) | 1.537604326 |
| Kurtosis | 0.7219639341 |
| Mean | 1.951867102 |
| Median Absolute Deviation (MAD) | 2.411418961 |
| Skewness | 1.446059625 |
| Sum | 13747 |
| Variance | 9.007197238 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 1.5 10.5 11. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 3821 | 54.3% | |
| 1 | 1086 | 15.4% | |
| 5 | 264 | 3.7% | |
| 3 | 255 | 3.6% | |
| 7 | 248 | 3.5% | |
| 9 | 238 | 3.4% | |
| 2 | 236 | 3.4% | |
| 4 | 236 | 3.4% | |
| 10 | 223 | 3.2% | |
| 6 | 221 | 3.1% | |
| Other values (2) | 215 | 3.1% |
| Value | Count | Frequency (%) | |
| 0 | 3821 | 54.3% | |
| 1 | 1086 | 15.4% | |
| 2 | 236 | 3.4% | |
| 3 | 255 | 3.6% | |
| 4 | 236 | 3.4% |
| Value | Count | Frequency (%) | |
| 11 | 2 | < 0.1% | |
| 10 | 223 | 3.2% | |
| 9 | 238 | 3.4% | |
| 8 | 213 | 3.0% | |
| 7 | 248 | 3.5% |
Offer
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| None | |
|---|---|
| Offer B | |
| Offer E | |
| Offer D | 602 |
| Offer A | 520 |
| Value | Count | Frequency (%) | |
| None | 3877 | 55.0% | |
| Offer B | 824 | 11.7% | |
| Offer E | 805 | 11.4% | |
| Offer D | 602 | 8.5% | |
| Offer A | 520 | 7.4% | |
| Offer C | 415 | 5.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 7 |
|---|---|
| Mean length | 5.348573051 |
| Min length | 4 |
Online_Backup
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4614 | 65.5% | |
| Yes | 2429 | 34.5% |
Online_Security
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 5024 | 71.3% | |
| Yes | 2019 | 28.7% |
Paperless_Billing
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Yes | |
|---|---|
| No |
| Value | Count | Frequency (%) | |
| Yes | 4171 | 59.2% | |
| No | 2872 | 40.8% |
Payment_Method
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Bank Withdrawal | |
|---|---|
| Credit Card | |
| Mailed Check | 385 |
| Value | Count | Frequency (%) | |
| Bank Withdrawal | 3909 | 55.5% | |
| Credit Card | 2749 | 39.0% | |
| Mailed Check | 385 | 5.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 15 |
|---|---|
| Mean length | 13.27474088 |
| Min length | 11 |
Phone_Service
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Yes | |
|---|---|
| No | 682 |
| Value | Count | Frequency (%) | |
| Yes | 6361 | 90.3% | |
| No | 682 | 9.7% |
Population
Real number (ℝ≥0)
| Distinct count | 1569 |
|---|---|
| Unique (%) | 22.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22139.60329 |
|---|---|
| Minimum | 11 |
| Maximum | 105285 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 227 |
| Q1 | 2344 |
| median | 17554 |
| Q3 | 36125 |
| 95-th percentile | 62065.7 |
| Maximum | 105285 |
| Range | 105274 |
| Interquartile range (IQR) | 33781 |
Descriptive statistics
| Standard deviation | 21152.39284 |
|---|---|
| Coefficient of variation (CV) | 0.9554097495 |
| Kurtosis | 0.3254602142 |
| Mean | 22139.60329 |
| Median Absolute Deviation (MAD) | 17624.79706 |
| Skewness | 0.9128540219 |
| Sum | 155929226 |
| Variance | 447423722.7 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.10000e+01 7.00000e+01 9.20000e+01 2.61500e+02 2.65500e+02 ... 6.33125e+04 7.41285e+04 7.44365e+04 8.23080e+04 1.05285e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 42239 | 43 | 0.6% | |
| 48690 | 38 | 0.5% | |
| 34902 | 36 | 0.5% | |
| 51213 | 34 | 0.5% | |
| 74232 | 32 | 0.5% | |
| 46171 | 30 | 0.4% | |
| 46086 | 27 | 0.4% | |
| 28201 | 22 | 0.3% | |
| 4258 | 20 | 0.3% | |
| 88 | 20 | 0.3% | |
| Other values (1559) | 6741 | 95.7% |
| Value | Count | Frequency (%) | |
| 11 | 5 | 0.1% | |
| 19 | 4 | 0.1% | |
| 21 | 9 | 0.1% | |
| 23 | 3 | < 0.1% | |
| 25 | 4 | 0.1% |
| Value | Count | Frequency (%) | |
| 105285 | 5 | 0.1% | |
| 103214 | 5 | 0.1% | |
| 101215 | 5 | 0.1% | |
| 98239 | 5 | 0.1% | |
| 97318 | 5 | 0.1% |
Premium_Tech_Support
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4999 | 71.0% | |
| Yes | 2044 | 29.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Q3 |
|---|
| Value | Count | Frequency (%) | |
| Q3 | 7043 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
Referred_a_Friend
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 3821 | 54.3% | |
| Yes | 3222 | 45.7% |
Satisfaction_Score
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.244924038 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.201657123 |
|---|---|
| Coefficient of variation (CV) | 0.3703190301 |
| Kurtosis | -0.5368532045 |
| Mean | 3.244924038 |
| Median Absolute Deviation (MAD) | 0.9562439802 |
| Skewness | -0.3674005424 |
| Sum | 22854 |
| Variance | 1.44397984 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1. 2.5 3.5 4.5 5. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3 | 2665 | 37.8% | |
| 4 | 1789 | 25.4% | |
| 5 | 1149 | 16.3% | |
| 1 | 922 | 13.1% | |
| 2 | 518 | 7.4% |
| Value | Count | Frequency (%) | |
| 1 | 922 | 13.1% | |
| 2 | 518 | 7.4% | |
| 3 | 2665 | 37.8% | |
| 4 | 1789 | 25.4% | |
| 5 | 1149 | 16.3% |
| Value | Count | Frequency (%) | |
| 5 | 1149 | 16.3% | |
| 4 | 1789 | 25.4% | |
| 3 | 2665 | 37.8% | |
| 2 | 518 | 7.4% | |
| 1 | 922 | 13.1% |
Senior_Citizen
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes | 1142 |
| Value | Count | Frequency (%) | |
| No | 5901 | 83.8% | |
| Yes | 1142 | 16.2% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| California |
|---|
| Value | Count | Frequency (%) | |
| California | 7043 | 100.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
Streaming_Movies
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4311 | 61.2% | |
| Yes | 2732 | 38.8% |
Streaming_Music
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4555 | 64.7% | |
| Yes | 2488 | 35.3% |
Streaming_TV
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 4336 | 61.6% | |
| Yes | 2707 | 38.4% |
Tenure_in_Months
Real number (ℝ≥0)
| Distinct count | 72 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.386767 |
|---|---|
| Minimum | 1 |
| Maximum | 72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 29 |
| Q3 | 55 |
| 95-th percentile | 72 |
| Maximum | 72 |
| Range | 71 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 24.54206101 |
|---|---|
| Coefficient of variation (CV) | 0.757780516 |
| Kurtosis | -1.387052361 |
| Mean | 32.386767 |
| Median Absolute Deviation (MAD) | 21.85859589 |
| Skewness | 0.2405426141 |
| Sum | 228100 |
| Variance | 602.3127587 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 1. 1.5 4.5 13.5 26.5 65.5 70.5 71.5 72. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 613 | 8.7% | |
| 72 | 362 | 5.1% | |
| 2 | 238 | 3.4% | |
| 3 | 200 | 2.8% | |
| 4 | 176 | 2.5% | |
| 71 | 170 | 2.4% | |
| 5 | 133 | 1.9% | |
| 7 | 131 | 1.9% | |
| 10 | 127 | 1.8% | |
| 8 | 123 | 1.7% | |
| Other values (62) | 4770 | 67.7% |
| Value | Count | Frequency (%) | |
| 1 | 613 | 8.7% | |
| 2 | 238 | 3.4% | |
| 3 | 200 | 2.8% | |
| 4 | 176 | 2.5% | |
| 5 | 133 | 1.9% |
| Value | Count | Frequency (%) | |
| 72 | 362 | 5.1% | |
| 71 | 170 | 2.4% | |
| 70 | 119 | 1.7% | |
| 69 | 95 | 1.3% | |
| 68 | 100 | 1.4% |
| Distinct count | 6540 |
|---|---|
| Unique (%) | 92.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2280.381264 |
|---|---|
| Minimum | 18.8 |
| Maximum | 8684.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 18.8 |
|---|---|
| 5-th percentile | 49.65 |
| Q1 | 400.15 |
| median | 1394.55 |
| Q3 | 3786.6 |
| 95-th percentile | 6921.025 |
| Maximum | 8684.8 |
| Range | 8666 |
| Interquartile range (IQR) | 3386.45 |
Descriptive statistics
| Standard deviation | 2266.220462 |
|---|---|
| Coefficient of variation (CV) | 0.9937901605 |
| Kurtosis | -0.2276926647 |
| Mean | 2280.381264 |
| Median Absolute Deviation (MAD) | 1898.648455 |
| Skewness | 0.9637910861 |
| Sum | 16060725.24 |
| Variance | 5135755.182 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 18.8 19.425 20.525 21.075 24.025 ... 2665.875 5044. 6893.475 8128.45 8684.8 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 20.2 | 11 | 0.2% | |
| 19.75 | 9 | 0.1% | |
| 19.9 | 8 | 0.1% | |
| 19.65 | 8 | 0.1% | |
| 20.05 | 8 | 0.1% | |
| 19.55 | 7 | 0.1% | |
| 45.3 | 7 | 0.1% | |
| 19.45 | 6 | 0.1% | |
| 20.25 | 6 | 0.1% | |
| 20.15 | 6 | 0.1% | |
| Other values (6530) | 6967 | 98.9% |
| Value | Count | Frequency (%) | |
| 18.8 | 1 | < 0.1% | |
| 18.85 | 2 | < 0.1% | |
| 18.9 | 1 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 19.05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 8684.8 | 1 | < 0.1% | |
| 8672.45 | 1 | < 0.1% | |
| 8670.1 | 1 | < 0.1% | |
| 8594.4 | 1 | < 0.1% | |
| 8564.75 | 1 | < 0.1% |
| Distinct count | 16 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.860712764 |
|---|---|
| Minimum | 0 |
| Maximum | 150 |
| Zeros | 6315 |
| Zeros (%) | 89.7% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 60 |
| Maximum | 150 |
| Range | 150 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 25.104978 |
|---|---|
| Coefficient of variation (CV) | 3.659237584 |
| Kurtosis | 16.45887408 |
| Mean | 6.860712764 |
| Median Absolute Deviation (MAD) | 12.30310978 |
| Skewness | 4.091209239 |
| Sum | 48320 |
| Variance | 630.2599204 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 5. 15. 45. 145. 150.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 6315 | 89.7% | |
| 10 | 138 | 2.0% | |
| 40 | 62 | 0.9% | |
| 30 | 58 | 0.8% | |
| 20 | 51 | 0.7% | |
| 80 | 47 | 0.7% | |
| 100 | 44 | 0.6% | |
| 50 | 43 | 0.6% | |
| 150 | 42 | 0.6% | |
| 130 | 40 | 0.6% | |
| Other values (6) | 203 | 2.9% |
| Value | Count | Frequency (%) | |
| 0 | 6315 | 89.7% | |
| 10 | 138 | 2.0% | |
| 20 | 51 | 0.7% | |
| 30 | 58 | 0.8% | |
| 40 | 62 | 0.9% |
| Value | Count | Frequency (%) | |
| 150 | 42 | 0.6% | |
| 140 | 38 | 0.5% | |
| 130 | 40 | 0.6% | |
| 120 | 28 | 0.4% | |
| 110 | 32 | 0.5% |
| Distinct count | 6110 |
|---|---|
| Unique (%) | 86.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 749.0992617 |
|---|---|
| Minimum | 0 |
| Maximum | 3564.72 |
| Zeros | 682 |
| Zeros (%) | 9.7% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 70.545 |
| median | 401.44 |
| Q3 | 1191.1 |
| 95-th percentile | 2577.877 |
| Maximum | 3564.72 |
| Range | 3564.72 |
| Interquartile range (IQR) | 1120.555 |
Descriptive statistics
| Standard deviation | 846.6600548 |
|---|---|
| Coefficient of variation (CV) | 1.130237471 |
| Kurtosis | 0.644092077 |
| Mean | 749.0992617 |
| Median Absolute Deviation (MAD) | 685.4550439 |
| Skewness | 1.238281984 |
| Sum | 5275906.1 |
| Variance | 716833.2484 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.000000e+00 5.650000e-01 3.670000e+00 4.991000e+01 1.510550e+02 ... 1.203040e+03 1.896900e+03 2.433145e+03 2.883805e+03 3.564720e+03], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 682 | 9.7% | |
| 22.86 | 4 | 0.1% | |
| 48.96 | 4 | 0.1% | |
| 597.6 | 3 | < 0.1% | |
| 200.34 | 3 | < 0.1% | |
| 378 | 3 | < 0.1% | |
| 198 | 3 | < 0.1% | |
| 95.64 | 3 | < 0.1% | |
| 41.1 | 3 | < 0.1% | |
| 15.28 | 3 | < 0.1% | |
| Other values (6100) | 6332 | 89.9% |
| Value | Count | Frequency (%) | |
| 0 | 682 | 9.7% | |
| 1.13 | 1 | < 0.1% | |
| 1.15 | 1 | < 0.1% | |
| 1.17 | 1 | < 0.1% | |
| 1.23 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3564.72 | 1 | < 0.1% | |
| 3564 | 1 | < 0.1% | |
| 3536.64 | 1 | < 0.1% | |
| 3515.92 | 1 | < 0.1% | |
| 3508.82 | 1 | < 0.1% |
| Distinct count | 500 |
|---|---|
| Unique (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.962182309 |
|---|---|
| Minimum | 0 |
| Maximum | 49.79 |
| Zeros | 6518 |
| Zeros (%) | 92.5% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 18.149 |
| Maximum | 49.79 |
| Range | 49.79 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.902614384 |
|---|---|
| Coefficient of variation (CV) | 4.027461847 |
| Kurtosis | 18.35065824 |
| Mean | 1.962182309 |
| Median Absolute Deviation (MAD) | 3.633345481 |
| Skewness | 4.328516701 |
| Sum | 13819.65 |
| Variance | 62.45131411 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.505 49.79 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 6518 | 92.5% | |
| 18.55 | 2 | < 0.1% | |
| 47.04 | 2 | < 0.1% | |
| 28.42 | 2 | < 0.1% | |
| 15.41 | 2 | < 0.1% | |
| 27.6 | 2 | < 0.1% | |
| 32.55 | 2 | < 0.1% | |
| 12.48 | 2 | < 0.1% | |
| 47.73 | 2 | < 0.1% | |
| 46.06 | 2 | < 0.1% | |
| Other values (490) | 507 | 7.2% |
| Value | Count | Frequency (%) | |
| 0 | 6518 | 92.5% | |
| 1.01 | 1 | < 0.1% | |
| 1.09 | 1 | < 0.1% | |
| 1.27 | 1 | < 0.1% | |
| 1.31 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 49.79 | 1 | < 0.1% | |
| 49.76 | 1 | < 0.1% | |
| 49.57 | 2 | < 0.1% | |
| 49.53 | 1 | < 0.1% | |
| 49.51 | 1 | < 0.1% |
| Distinct count | 6996 |
|---|---|
| Unique (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3034.379056 |
|---|---|
| Minimum | 21.36 |
| Maximum | 11979.34 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 21.36 |
|---|---|
| 5-th percentile | 78.452 |
| Q1 | 605.61 |
| median | 2108.64 |
| Q3 | 4801.145 |
| 95-th percentile | 8747.041 |
| Maximum | 11979.34 |
| Range | 11957.98 |
| Interquartile range (IQR) | 4195.535 |
Descriptive statistics
| Standard deviation | 2865.204542 |
|---|---|
| Coefficient of variation (CV) | 0.9442474025 |
| Kurtosis | -0.2034573897 |
| Mean | 3034.379056 |
| Median Absolute Deviation (MAD) | 2381.222402 |
| Skewness | 0.919410268 |
| Sum | 21371131.69 |
| Variance | 8209397.065 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 21.36 24.095 25.3 80.9 123.3 ... 4784.79 8735.25 10218.615 11037.435 11979.34 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 66.56 | 3 | < 0.1% | |
| 24.8 | 3 | < 0.1% | |
| 68.41 | 3 | < 0.1% | |
| 2997.45 | 2 | < 0.1% | |
| 118.98 | 2 | < 0.1% | |
| 790.7 | 2 | < 0.1% | |
| 25.25 | 2 | < 0.1% | |
| 343.68 | 2 | < 0.1% | |
| 35.25 | 2 | < 0.1% | |
| 4211.6 | 2 | < 0.1% | |
| Other values (6986) | 7020 | 99.7% |
| Value | Count | Frequency (%) | |
| 21.36 | 1 | < 0.1% | |
| 21.4 | 1 | < 0.1% | |
| 21.61 | 1 | < 0.1% | |
| 22.08 | 1 | < 0.1% | |
| 22.12 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11979.34 | 1 | < 0.1% | |
| 11868.34 | 1 | < 0.1% | |
| 11795.78 | 1 | < 0.1% | |
| 11688.9 | 1 | < 0.1% | |
| 11634.53 | 1 | < 0.1% |
Under_30
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| No | |
|---|---|
| Yes |
| Value | Count | Frequency (%) | |
| No | 5642 | 80.1% | |
| Yes | 1401 | 19.9% |
Unlimited_Data
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 338.5 KiB |
| Yes | |
|---|---|
| No |
| Value | Count | Frequency (%) | |
| Yes | 4745 | 67.4% | |
| No | 2298 | 32.6% |
| Distinct count | 1626 |
|---|---|
| Unique (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 93486.07057 |
|---|---|
| Minimum | 90001 |
| Maximum | 96150 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 366.0 KiB |
Quantile statistics
| Minimum | 90001 |
|---|---|
| 5-th percentile | 90241.1 |
| Q1 | 92101 |
| median | 93518 |
| Q3 | 95329 |
| 95-th percentile | 96020.9 |
| Maximum | 96150 |
| Range | 6149 |
| Interquartile range (IQR) | 3228 |
Descriptive statistics
| Standard deviation | 1856.767505 |
|---|---|
| Coefficient of variation (CV) | 0.01986143491 |
| Kurtosis | -1.173915431 |
| Mean | 93486.07057 |
| Median Absolute Deviation (MAD) | 1621.121476 |
| Skewness | -0.2096151191 |
| Sum | 658422395 |
| Variance | 3447585.568 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[90001. 90048.5 90056.5 90074. 90205.5 ... 95770.5 95814.5 95842.5 95911. 96150. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 92028 | 43 | 0.6% | |
| 92027 | 38 | 0.5% | |
| 92122 | 36 | 0.5% | |
| 92117 | 34 | 0.5% | |
| 92126 | 32 | 0.5% | |
| 92592 | 30 | 0.4% | |
| 92109 | 27 | 0.4% | |
| 92130 | 22 | 0.3% | |
| 92121 | 20 | 0.3% | |
| 92129 | 16 | 0.2% | |
| Other values (1616) | 6745 | 95.8% |
| Value | Count | Frequency (%) | |
| 90001 | 4 | 0.1% | |
| 90002 | 4 | 0.1% | |
| 90003 | 5 | 0.1% | |
| 90004 | 5 | 0.1% | |
| 90005 | 4 | 0.1% |
| Value | Count | Frequency (%) | |
| 96150 | 2 | < 0.1% | |
| 96148 | 4 | 0.1% | |
| 96146 | 4 | 0.1% | |
| 96145 | 3 | < 0.1% | |
| 96143 | 4 | 0.1% |
First rows
| Age | Avg_Monthly_GB_Download | Avg_Monthly_Long_Distance_Charges | Churn_Category | Churn_Label | Churn_Reason | Churn_Score | Churn_Value | City | CLTV | Contract | Count | Country | Customer_ID | Customer_Status | Dependents | Device_Protection_Plan | Gender | ID | Internet_Service | Internet_Type | Lat_Long | Latitude | Longitude | Married | Monthly_Charge | Multiple_Lines | Number_of_Dependents | Number_of_Referrals | Offer | Online_Backup | Online_Security | Paperless_Billing | Payment_Method | Phone_Service | Population | Premium_Tech_Support | Quarter | Referred_a_Friend | Satisfaction_Score | Senior_Citizen | State | Streaming_Movies | Streaming_Music | Streaming_TV | Tenure_in_Months | Total_Charges | Total_Extra_Data_Charges | Total_Long_Distance_Charges | Total_Refunds | Total_Revenue | Under_30 | Unlimited_Data | Zip_Code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 78 | 8 | 0.00 | Competitor | Yes | Competitor offered more data | 91 | 1 | Los Angeles | 5433 | Month-to-Month | 1 | United States | 8779-QRDMV | Churned | No | Yes | Male | 21 | Yes | DSL | 34.02381, -118.156582 | 34.023810 | -118.156582 | No | 39.65 | No | 0 | 0 | None | No | No | Yes | Bank Withdrawal | No | 68701 | No | Q3 | No | 3 | Yes | California | Yes | No | No | 1 | 39.65 | 20 | 0.00 | 0.00 | 59.65 | No | No | 90022 |
| 1 | 39 | 18 | 42.55 | NaN | No | NaN | 42 | 0 | Los Angeles | 4658 | Two Year | 1 | United States | 4737-AQCPU | Stayed | No | Yes | Male | 21 | Yes | DSL | 34.02381, -118.156582 | 34.023810 | -118.156582 | Yes | 72.10 | Yes | 0 | 5 | None | Yes | Yes | No | Credit Card | Yes | 68701 | Yes | Q3 | Yes | 3 | No | California | No | No | No | 72 | 5016.65 | 0 | 3063.60 | 0.00 | 8080.25 | No | Yes | 90022 |
| 2 | 32 | 26 | 7.11 | NaN | No | NaN | 34 | 0 | Los Angeles | 3503 | Month-to-Month | 1 | United States | 5043-TRZWM | Joined | No | Yes | Female | 21 | Yes | Fiber Optic | 34.02381, -118.156582 | 34.023810 | -118.156582 | No | 75.55 | No | 0 | 0 | None | No | No | No | Bank Withdrawal | Yes | 68701 | No | Q3 | No | 5 | No | California | No | No | No | 1 | 75.55 | 0 | 7.11 | 0.00 | 82.66 | No | Yes | 90022 |
| 3 | 35 | 25 | 0.00 | NaN | No | NaN | 46 | 0 | Los Angeles | 5748 | Two Year | 1 | United States | 8165-CBKXO | Stayed | Yes | Yes | Male | 21 | Yes | Cable | 34.02381, -118.156582 | 34.023810 | -118.156582 | Yes | 56.75 | No | 3 | 4 | None | Yes | No | Yes | Credit Card | No | 68701 | No | Q3 | Yes | 3 | No | California | Yes | Yes | Yes | 66 | 3708.40 | 0 | 0.00 | 0.00 | 3708.40 | No | Yes | 90022 |
| 4 | 20 | 42 | 36.49 | NaN | No | NaN | 38 | 0 | Los Angeles | 5545 | One Year | 1 | United States | 9979-RGMZT | Stayed | No | No | Female | 21 | Yes | Fiber Optic | 34.02381, -118.156582 | 34.023810 | -118.156582 | No | 94.05 | No | 0 | 0 | Offer E | Yes | No | Yes | Credit Card | Yes | 68701 | No | Q3 | No | 3 | No | California | Yes | Yes | Yes | 7 | 633.45 | 0 | 255.43 | 0.00 | 888.88 | Yes | Yes | 90022 |
| 5 | 74 | 17 | 48.85 | Competitor | Yes | Competitor made better offer | 69 | 1 | Los Angeles | 5302 | Month-to-Month | 1 | United States | 7495-OOKFY | Churned | Yes | No | Female | 54 | Yes | Fiber Optic | 34.044271, -118.185237 | 34.044271 | -118.185237 | Yes | 80.65 | Yes | 1 | 1 | Offer E | Yes | No | Yes | Credit Card | Yes | 55668 | No | Q3 | Yes | 3 | Yes | California | No | No | No | 8 | 633.30 | 0 | 390.80 | 0.00 | 1024.10 | No | Yes | 90063 |
| 6 | 68 | 21 | 22.74 | NaN | No | NaN | 42 | 0 | Los Angeles | 5140 | Two Year | 1 | United States | 4918-FYJNT | Stayed | No | Yes | Female | 54 | Yes | Fiber Optic | 34.044271, -118.185237 | 34.044271 | -118.185237 | Yes | 90.45 | Yes | 0 | 4 | None | Yes | No | No | Bank Withdrawal | Yes | 55668 | Yes | Q3 | Yes | 4 | Yes | California | No | No | No | 55 | 5044.80 | 0 | 1250.70 | 12.48 | 6283.02 | No | Yes | 90063 |
| 7 | 40 | 24 | 13.58 | Dissatisfaction | Yes | Service dissatisfaction | 65 | 1 | Los Angeles | 5020 | Month-to-Month | 1 | United States | 3891-PUQOD | Churned | Yes | Yes | Female | 54 | Yes | DSL | 34.044271, -118.185237 | 34.044271 | -118.185237 | No | 59.20 | No | 3 | 0 | None | No | No | No | Bank Withdrawal | Yes | 55668 | No | Q3 | No | 1 | No | California | Yes | Yes | No | 1 | 59.20 | 0 | 13.58 | 0.00 | 72.78 | No | Yes | 90063 |
| 8 | 28 | 41 | 43.77 | NaN | No | NaN | 42 | 0 | Los Angeles | 5845 | One Year | 1 | United States | 0052-DCKON | Stayed | No | Yes | Male | 54 | Yes | Fiber Optic | 34.044271, -118.185237 | 34.044271 | -118.185237 | Yes | 115.80 | Yes | 0 | 9 | None | Yes | Yes | No | Bank Withdrawal | Yes | 55668 | Yes | Q3 | Yes | 3 | No | California | Yes | Yes | Yes | 66 | 7942.15 | 0 | 2888.82 | 0.00 | 10830.97 | Yes | Yes | 90063 |
| 9 | 49 | 53 | 0.00 | NaN | No | NaN | 47 | 0 | Los Angeles | 5498 | Two Year | 1 | United States | 3704-IEAXF | Stayed | Yes | No | Female | 54 | Yes | DSL | 34.044271, -118.185237 | 34.044271 | -118.185237 | Yes | 53.65 | No | 3 | 9 | None | Yes | No | No | Credit Card | No | 55668 | Yes | Q3 | Yes | 3 | No | California | Yes | Yes | Yes | 72 | 3784.00 | 0 | 0.00 | 0.00 | 3784.00 | No | Yes | 90063 |
Last rows
| Age | Avg_Monthly_GB_Download | Avg_Monthly_Long_Distance_Charges | Churn_Category | Churn_Label | Churn_Reason | Churn_Score | Churn_Value | City | CLTV | Contract | Count | Country | Customer_ID | Customer_Status | Dependents | Device_Protection_Plan | Gender | ID | Internet_Service | Internet_Type | Lat_Long | Latitude | Longitude | Married | Monthly_Charge | Multiple_Lines | Number_of_Dependents | Number_of_Referrals | Offer | Online_Backup | Online_Security | Paperless_Billing | Payment_Method | Phone_Service | Population | Premium_Tech_Support | Quarter | Referred_a_Friend | Satisfaction_Score | Senior_Citizen | State | Streaming_Movies | Streaming_Music | Streaming_TV | Tenure_in_Months | Total_Charges | Total_Extra_Data_Charges | Total_Long_Distance_Charges | Total_Refunds | Total_Revenue | Under_30 | Unlimited_Data | Zip_Code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7033 | 27 | 0 | 11.57 | NaN | No | NaN | 29 | 0 | Alturas | 5962 | Two Year | 1 | United States | 5647-URDKA | Stayed | Yes | No | Male | 1632 | No | None | 41.468877, -120.54229 | 41.468877 | -120.542290 | Yes | 19.70 | No | 1 | 8 | None | No | No | No | Credit Card | Yes | 5096 | No | Q3 | Yes | 4 | No | California | No | No | No | 8 | 130.25 | 0 | 92.56 | 0.0 | 222.81 | Yes | No | 96101 |
| 7034 | 29 | 85 | 27.37 | NaN | No | NaN | 80 | 0 | Topaz | 2200 | Month-to-Month | 1 | United States | 9143-CANJF | Stayed | Yes | No | Female | 1659 | Yes | DSL | 38.636052, -119.489162 | 38.636052 | -119.489162 | Yes | 55.15 | No | 3 | 7 | None | No | Yes | No | Bank Withdrawal | Yes | 116 | Yes | Q3 | Yes | 3 | No | California | No | No | No | 24 | 1319.85 | 0 | 656.88 | 0.0 | 1976.73 | Yes | Yes | 96133 |
| 7035 | 33 | 26 | 3.09 | NaN | No | NaN | 21 | 0 | Topaz | 5619 | Two Year | 1 | United States | 4973-MGTON | Stayed | No | Yes | Female | 1659 | Yes | DSL | 38.636052, -119.489162 | 38.636052 | -119.489162 | Yes | 84.40 | No | 0 | 0 | None | Yes | Yes | Yes | Credit Card | Yes | 116 | Yes | Q3 | No | 5 | No | California | Yes | Yes | Yes | 71 | 5969.30 | 0 | 219.39 | 0.0 | 6188.69 | No | Yes | 96133 |
| 7036 | 34 | 19 | 28.21 | NaN | No | NaN | 68 | 0 | Topaz | 4668 | Two Year | 1 | United States | 5702-KVQRD | Stayed | No | Yes | Male | 1659 | Yes | DSL | 38.636052, -119.489162 | 38.636052 | -119.489162 | Yes | 82.55 | No | 0 | 2 | Offer A | No | Yes | Yes | Bank Withdrawal | Yes | 116 | Yes | Q3 | Yes | 3 | No | California | Yes | Yes | Yes | 71 | 5832.65 | 0 | 2002.91 | 0.0 | 7835.56 | No | Yes | 96133 |
| 7037 | 34 | 27 | 4.89 | NaN | No | NaN | 47 | 0 | Jacumba | 2711 | Month-to-Month | 1 | United States | 8148-BPLZQ | Stayed | No | No | Male | 303 | Yes | Cable | 32.649787, -116.2237 | 32.649787 | -116.223700 | No | 49.80 | No | 0 | 0 | None | Yes | No | Yes | Bank Withdrawal | Yes | 699 | No | Q3 | No | 4 | No | California | No | No | No | 34 | 1734.20 | 70 | 166.26 | 0.0 | 1970.46 | No | No | 91934 |
| 7038 | 21 | 59 | 16.06 | NaN | No | NaN | 62 | 0 | Jacumba | 4504 | Month-to-Month | 1 | United States | 9108-EJFJP | Joined | No | No | Female | 303 | Yes | DSL | 32.649787, -116.2237 | 32.649787 | -116.223700 | Yes | 53.55 | No | 0 | 6 | Offer E | Yes | Yes | Yes | Credit Card | Yes | 699 | No | Q3 | Yes | 4 | No | California | No | Yes | No | 1 | 53.55 | 0 | 16.06 | 0.0 | 69.61 | Yes | Yes | 91934 |
| 7039 | 36 | 24 | 23.13 | NaN | No | NaN | 26 | 0 | San Diego | 5416 | One Year | 1 | United States | 0795-GMVQO | Stayed | No | Yes | Male | 357 | Yes | Fiber Optic | 32.741859, -117.090353 | 32.741859 | -117.090353 | Yes | 109.90 | Yes | 0 | 1 | None | Yes | Yes | No | Credit Card | Yes | 73006 | No | Q3 | Yes | 4 | No | California | Yes | Yes | Yes | 67 | 7332.40 | 0 | 1549.71 | 0.0 | 8882.11 | No | Yes | 92105 |
| 7040 | 32 | 30 | 23.42 | NaN | No | NaN | 32 | 0 | San Diego | 4062 | Month-to-Month | 1 | United States | 9547-ITEFG | Stayed | Yes | Yes | Male | 357 | Yes | Fiber Optic | 32.741859, -117.090353 | 32.741859 | -117.090353 | Yes | 102.60 | Yes | 3 | 8 | Offer E | Yes | No | Yes | Credit Card | Yes | 73006 | No | Q3 | Yes | 5 | No | California | Yes | Yes | Yes | 9 | 897.75 | 0 | 210.78 | 0.0 | 1108.53 | No | Yes | 92105 |
| 7041 | 62 | 30 | 37.69 | NaN | No | NaN | 66 | 0 | Holtville | 5471 | Month-to-Month | 1 | United States | 4993-JCRGJ | Stayed | No | Yes | Male | 404 | Yes | Fiber Optic | 32.811001, -115.152865 | 32.811001 | -115.152865 | No | 84.30 | Yes | 0 | 0 | None | No | No | Yes | Credit Card | Yes | 8062 | Yes | Q3 | No | 5 | No | California | No | No | No | 26 | 2281.60 | 0 | 979.94 | 0.0 | 3261.54 | No | Yes | 92250 |
| 7042 | 50 | 0 | 31.33 | NaN | No | NaN | 22 | 0 | Holtville | 4769 | Month-to-Month | 1 | United States | 6082-GLJIX | Stayed | No | No | Male | 404 | No | None | 32.811001, -115.152865 | 32.811001 | -115.152865 | No | 19.25 | No | 0 | 0 | Offer D | No | No | No | Credit Card | Yes | 8062 | No | Q3 | No | 5 | No | California | No | No | No | 18 | 331.35 | 0 | 563.94 | 0.0 | 895.29 | No | No | 92250 |